<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->


<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="zh-cn" xml:lang="zh-cn">
<head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
   
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="DC.Type" content="topic">
<meta name="DC.Title" content="查看SQL Server数据库环境信息">
<meta name="product" content="">
<meta name="DC.Relation" scheme="URI" content="sql-0069.html">
<meta name="prodname" content="">
<meta name="version" content="">
<meta name="brand" content="30-OceanProtect 备份一体机 1.5.0-1.6.0 帮助中心">
<meta name="DC.Publisher" content="20240320">
<meta name="prodname" content="csbs">
<meta name="documenttype" content="usermanual">
<meta name="DC.Format" content="XHTML">
<meta name="DC.Identifier" content="sql-0070">
<meta name="DC.Language" content="zh-cn">
<link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
<title>查看SQL Server数据库环境信息</title>
</head>
<body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px"><a name="sql-0070"></a><a name="sql-0070"></a>

<h1 class="topictitle1">查看SQL Server数据库环境信息</h1>
<div><p>当SQL Server数据库已注册至<span>OceanProtect</span>后，您可以在管理界面查看数据库及其所在主机或所属集群/可用性组的详细信息。</p>
<div class="section"><h4 class="sectiontitle">操作步骤</h4><ol><li><span>选择<span class="uicontrol" id="sql-0070__zh-cn_topic_0000001839142377_uicontrol114088356363">“<span id="sql-0070__zh-cn_topic_0000001839142377_text1840913533616">保护</span> &gt; 数据库 &gt; SQL Server”</span>。</span></li><li><span>查看详细信息。</span><p><ul><li>在<span class="uicontrol">“集群”</span>页签浏览SQL Server集群信息。<p>当集群有数据库已通过注册，集群信息会显示在该页面。</p>
<div class="p">详细信息如<a href="#sql-0070__table1680311315916">表1</a>所示。
<div class="tablenoborder"><a name="sql-0070__table1680311315916"></a><a name="table1680311315916"></a><table cellpadding="4" cellspacing="0" summary="" id="sql-0070__table1680311315916" frame="border" border="1" rules="all"><caption><b>表1 </b>集群信息</caption><colgroup><col style="width:20.31%"><col style="width:79.69000000000001%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="20.31%" id="mcps1.3.2.2.2.2.1.1.3.2.2.3.1.1"><p>参数</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="79.69000000000001%" id="mcps1.3.2.2.2.2.1.1.3.2.2.3.1.2"><p>说明</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.2.2.2.2.1.1.3.2.2.3.1.1 "><p><span>名称</span></p>
</td>
<td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.2.2.2.2.1.1.3.2.2.3.1.2 "><p>数据库集群名称。</p>
<ul><li>单击集群名称，显示当前集群的主机成员，及集群下已通过认证的所有数据库。</li></ul>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.2.2.2.2.1.1.3.2.2.3.1.1 "><p><span>状态</span></p>
</td>
<td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.2.2.2.2.1.1.3.2.2.3.1.2 "><div class="p">集群的状态。<ul><li><span>在线</span>：主机处于开机状态且主机上的ProtectAgent正常运行时，主机<span class="uicontrol">“<span>状态</span>”</span>为<span class="uicontrol">“<span>在线</span>”</span>。<p>集群中存在在线状态的主机时，集群状态为<span class="uicontrol">“<span>在线</span>”</span>。</p>
</li><li><span>离线</span>：主机关机或者主机上的ProtectAgent故障时，主机<span class="uicontrol">“<span>状态</span>”</span>为<span class="uicontrol">“<span>离线</span>”</span>。<p>集群中所有主机均离线时，集群状态为<span class="uicontrol">“<span>离线</span>”</span>。</p>
</li></ul>
</div>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.2.2.2.2.1.1.3.2.2.3.1.1 "><div class="p">标签<div class="note" id="sql-0070__zh-cn_topic_0000001792344110_note1330311543247"><span class="notetitle"> 说明： </span><div class="notebody"><p id="sql-0070__zh-cn_topic_0000001792344110_p630385412417">仅1.6.0及后续版本存在此参数。</p>
</div></div>
</div>
</td>
<td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.2.2.2.2.1.1.3.2.2.3.1.2 "><p>当资源已添加标签时，则此处显示标签名称。否则，显示“--”。</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</li><li>在<span class="uicontrol">“<span>实例</span>”</span>页签浏览数据库实例信息。<div class="p">数据库实例的详细信息如<a href="#sql-0070__table165331245151911">表2</a>所示。
<div class="tablenoborder"><a name="sql-0070__table165331245151911"></a><a name="table165331245151911"></a><table cellpadding="4" cellspacing="0" summary="" id="sql-0070__table165331245151911" frame="border" border="1" rules="all"><caption><b>表2 </b>数据库实例信息</caption><colgroup><col style="width:20.330000000000002%"><col style="width:79.67%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="20.330000000000002%" id="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.1"><p>参数</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="79.67%" id="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.2"><p>说明</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.1 "><p><span>名称</span></p>
</td>
<td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.2 "><p>数据库实例名称。</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.1 "><p>所属主机/集群</p>
</td>
<td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.2 "><p>数据库实例所在主机或集群的名称。</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.1 "><p>节点IP地址</p>
</td>
<td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.2 "><p>数据库实例所在的主机IP地址。</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.1 "><p><span>版本</span></p>
</td>
<td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.2 "><p>实例所在数据库的版本。</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.1 "><p><span>SLA</span></p>
</td>
<td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.2 "><p>当数据库已关联SLA时，则显示SLA名称，否则显示<span class="uicontrol" id="sql-0070__zh-cn_topic_0000001656761205_uicontrol9578183214495">“--”</span>。</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.1 "><p><span>SLA遵从度</span></p>
</td>
<td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.2 "><div class="p">SLA遵从度指某次备份任务是否按设定的备份频率或备份窗口成功完成备份。<ul id="sql-0070__zh-cn_topic_0000001792344110_zh-cn_topic_0000001792344094_ul1823814519293"><li id="sql-0070__zh-cn_topic_0000001792344110_zh-cn_topic_0000001792344094_li9238184572919">遵从：如果某次备份任务（首次全量备份除外）的备份时间满足备份窗口或备份频率要求，且备份成功，则表示SLA遵从。</li><li id="sql-0070__zh-cn_topic_0000001792344110_zh-cn_topic_0000001792344094_li189142052112912">不遵从：如果备份时间不满足备份窗口或备份频率要求，例如某次备份任务SLA设定的备份频率为每半小时执行一次，最终备份时间超过半小时，则表示SLA不遵从。建议调整备份频率或备份窗口。</li></ul>
</div>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.1 "><p><span>保护状态</span></p>
</td>
<td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.2 "><p>实例当前是否被保护。</p>
<ul><li><span>未保护</span>：实例未关联SLA，或者数据库已关联SLA但已禁用保护。</li><li><span>已保护</span>：实例已关联SLA，且已激活保护。</li><li><span>创建中</span>：实例已关联SLA，正在创建保护。</li></ul>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.1 "><div class="p">标签<div class="note" id="sql-0070__zh-cn_topic_0000001792344110_note1330311543247_1"><span class="notetitle"> 说明： </span><div class="notebody"><p id="sql-0070__zh-cn_topic_0000001792344110_p630385412417_1">仅1.6.0及后续版本存在此参数。</p>
</div></div>
</div>
</td>
<td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.2 "><p>当资源已添加标签时，则此处显示标签名称。否则，显示“--”。</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<ol type="a"><li>单击名称，查看总览信息、副本信息以及任务。<ul><li>总览<p>显示SLA信息、任务执行时间、副本总数、节点和数据库等信息。</p>
</li><li>副本数据<p>您可以依次按照年、月、天查找相应时间的副本。</p>
<p>时间下方显示<span><img src="zh-cn_image_0000002052052313.png"></span>，表示该时间存在副本。</p>
</li><li>任务<p>展示备份、恢复等任务。</p>
</li></ul>
</li></ol>
</li><li>在<span class="uicontrol">“<span>可用性组</span>”</span>页签浏览数据库可用性组信息。<div class="p">数据库可用性组的详细信息如<a href="#sql-0070__table977033115154">表3</a>所示。
<div class="tablenoborder"><a name="sql-0070__table977033115154"></a><a name="table977033115154"></a><table cellpadding="4" cellspacing="0" summary="" id="sql-0070__table977033115154" frame="border" border="1" rules="all"><caption><b>表3 </b>可用性组信息</caption><colgroup><col style="width:21.18%"><col style="width:78.82000000000001%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="21.18%" id="mcps1.3.2.2.2.2.1.3.2.2.2.3.1.1"><p>参数</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="78.82000000000001%" id="mcps1.3.2.2.2.2.1.3.2.2.2.3.1.2"><p>说明</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="21.18%" headers="mcps1.3.2.2.2.2.1.3.2.2.2.3.1.1 "><p><span>名称</span></p>
</td>
<td class="cellrowborder" valign="top" width="78.82000000000001%" headers="mcps1.3.2.2.2.2.1.3.2.2.2.3.1.2 "><p>数据库可用性组名称。</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="21.18%" headers="mcps1.3.2.2.2.2.1.3.2.2.2.3.1.1 "><p>所属集群</p>
</td>
<td class="cellrowborder" valign="top" width="78.82000000000001%" headers="mcps1.3.2.2.2.2.1.3.2.2.2.3.1.2 "><p>数据库可用性组所在集群的名称。</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="21.18%" headers="mcps1.3.2.2.2.2.1.3.2.2.2.3.1.1 "><p><span>SLA</span></p>
</td>
<td class="cellrowborder" valign="top" width="78.82000000000001%" headers="mcps1.3.2.2.2.2.1.3.2.2.2.3.1.2 "><p>当可用性组已关联SLA时，则显示SLA名称，否则显示<span class="uicontrol">“--”</span>。</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="21.18%" headers="mcps1.3.2.2.2.2.1.3.2.2.2.3.1.1 "><p><span>SLA遵从度</span></p>
</td>
<td class="cellrowborder" valign="top" width="78.82000000000001%" headers="mcps1.3.2.2.2.2.1.3.2.2.2.3.1.2 "><div class="p">SLA遵从度指某次备份任务是否按设定的备份频率或备份窗口成功完成备份。<ul id="sql-0070__zh-cn_topic_0000001792344110_zh-cn_topic_0000001792344094_ul1823814519293_1"><li id="sql-0070__zh-cn_topic_0000001792344110_zh-cn_topic_0000001792344094_li9238184572919_1">遵从：如果某次备份任务（首次全量备份除外）的备份时间满足备份窗口或备份频率要求，且备份成功，则表示SLA遵从。</li><li id="sql-0070__zh-cn_topic_0000001792344110_zh-cn_topic_0000001792344094_li189142052112912_1">不遵从：如果备份时间不满足备份窗口或备份频率要求，例如某次备份任务SLA设定的备份频率为每半小时执行一次，最终备份时间超过半小时，则表示SLA不遵从。建议调整备份频率或备份窗口。</li></ul>
</div>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="21.18%" headers="mcps1.3.2.2.2.2.1.3.2.2.2.3.1.1 "><p><span>保护状态</span></p>
</td>
<td class="cellrowborder" valign="top" width="78.82000000000001%" headers="mcps1.3.2.2.2.2.1.3.2.2.2.3.1.2 "><p>可用性组当前是否被保护。</p>
<ul><li><span>未保护</span>：可用性组未关联SLA，或者可用性组已关联SLA但已禁用保护。</li><li><span>已保护</span>：可用性组已关联SLA，且已激活保护。</li><li><span>创建中</span>：可用性组已关联SLA，正在创建保护。</li></ul>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="21.18%" headers="mcps1.3.2.2.2.2.1.3.2.2.2.3.1.1 "><div class="p">标签<div class="note" id="sql-0070__zh-cn_topic_0000001792344110_note1330311543247_2"><span class="notetitle"> 说明： </span><div class="notebody"><p id="sql-0070__zh-cn_topic_0000001792344110_p630385412417_2">仅1.6.0及后续版本存在此参数。</p>
</div></div>
</div>
</td>
<td class="cellrowborder" valign="top" width="78.82000000000001%" headers="mcps1.3.2.2.2.2.1.3.2.2.2.3.1.2 "><p>当资源已添加标签时，则此处显示标签名称。否则，显示“--”。</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<ol type="a"><li>单击名称，查看总览信息、副本信息以及任务。<ul><li>总览<p>显示SLA信息、任务执行时间、副本总数和保护对象等信息。</p>
</li><li>副本数据<p>您可以依次按照年、月、天查找相应时间的副本。</p>
<p>时间下方显示<span><img src="zh-cn_image_0000002016093606.png"></span>，表示该时间存在副本。</p>
</li><li>任务<p>展示备份、恢复等任务。</p>
</li></ul>
</li></ol>
</li><li>在<span class="uicontrol">“<span>数据库</span>”</span>页签浏览数据库信息。<p>该界面显示的是已扫描的数据库信息。</p>
<div class="p">数据库的详细信息如<a href="#sql-0070__table2382789197">表4</a>所示。
<div class="tablenoborder"><a name="sql-0070__table2382789197"></a><a name="table2382789197"></a><table cellpadding="4" cellspacing="0" summary="" id="sql-0070__table2382789197" frame="border" border="1" rules="all"><caption><b>表4 </b>数据库信息</caption><colgroup><col style="width:20.380000000000003%"><col style="width:79.62%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="20.380000000000003%" id="mcps1.3.2.2.2.2.1.4.3.2.2.3.1.1"><p>参数</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="79.62%" id="mcps1.3.2.2.2.2.1.4.3.2.2.3.1.2"><p>说明</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.4.3.2.2.3.1.1 "><p><span>名称</span></p>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.4.3.2.2.3.1.2 "><p>数据库名称。</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.4.3.2.2.3.1.1 "><p><span>所属主机/集群</span></p>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.4.3.2.2.3.1.2 "><p>数据库所在主机/集群的名称。</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.4.3.2.2.3.1.1 "><p><span>所属实例</span></p>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.4.3.2.2.3.1.2 "><p>单实例/集群实例名称。</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.4.3.2.2.3.1.1 "><p><span>SLA</span></p>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.4.3.2.2.3.1.2 "><p>当数据库已关联SLA时，则显示SLA名称，否则显示<span class="uicontrol">“--”</span>。</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.4.3.2.2.3.1.1 "><p><span>SLA遵从度</span></p>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.4.3.2.2.3.1.2 "><div class="p">SLA遵从度指某次备份任务是否按设定的备份频率或备份窗口成功完成备份。<ul id="sql-0070__zh-cn_topic_0000001656691393_zh-cn_topic_0000001656771381_ul1823814519293"><li id="sql-0070__zh-cn_topic_0000001656691393_zh-cn_topic_0000001656771381_li9238184572919">遵从：如果某次备份任务（首次全量备份除外）的备份时间满足备份窗口或备份频率要求，且备份成功，则表示SLA遵从。</li><li id="sql-0070__zh-cn_topic_0000001656691393_zh-cn_topic_0000001656771381_li189142052112912">不遵从：如果备份时间不满足备份窗口或备份频率要求，例如某次备份任务SLA设定的备份频率为每半小时执行一次，最终备份时间超过半小时，则表示SLA不遵从。建议调整备份频率或备份窗口。</li></ul>
</div>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.4.3.2.2.3.1.1 "><p><span>保护状态</span></p>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.4.3.2.2.3.1.2 "><p>数据库当前是否被保护。</p>
<ul><li><span>未保护</span>：数据库未关联SLA，或者数据库已关联SLA但已禁用保护。</li><li><span>已保护</span>：数据库已关联SLA，且已激活保护。</li><li><span>创建中</span>：数据库已关联SLA，正在创建保护。</li></ul>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.4.3.2.2.3.1.1 "><div class="p">标签<div class="note" id="sql-0070__zh-cn_topic_0000001792344110_note1330311543247_3"><span class="notetitle"> 说明： </span><div class="notebody"><p id="sql-0070__zh-cn_topic_0000001792344110_p630385412417_3">仅1.6.0及后续版本存在此参数。</p>
</div></div>
</div>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.4.3.2.2.3.1.2 "><p>当资源已添加标签时，则此处显示标签名称。否则，显示“--”。</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<ol type="a"><li>单击名称，查看总览信息、副本信息以及任务。<ul><li>总览<p>显示SLA信息、任务执行时间、副本总数等。</p>
</li><li>副本数据<p>您可以依次按照年、月、天查找相应时间的副本。</p>
<p>时间下方显示<span><img src="zh-cn_image_0000002052211377.png"></span>，表示该时间存在副本。</p>
</li><li>任务<p>展示备份、恢复等任务。</p>
</li></ul>
</li></ol>
</li></ul>
</p></li></ol>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>父主题：</strong> <a href="sql-0069.html">SQL Server数据库环境</a></div>
</div>
</div>

<div class="hrcopyright"><hr size="2"></div><div class="hwcopyright">版权所有 &copy; 华为技术有限公司</div></body>
</html>